Help Index
Scheduler

Commands

Scheduler Menu Commands

Scheduler DDE Commands

Command Line Parameters

Command Lines

Files Used

Scheduler Files

NOTE: The Scheduler cannot be shutdown directly. This function is controlled by the other applications running.


Scheduler Description
Help for the Scheduler

This help file is used for the Scheduler.

©  Medge 1994.


Menu Commands for the Scheduler

The Scheduler has a number of menu options:

Read File

Add An Item

Launch On Error

Pause Transmissions

Halt Transmissions

Clock

Enter logon details for SQL

Help

About


DDE Commands for the Scheduler

The Scheduler is designed to accept a DDE execute message in the form:

DD/MM/YYYY HH:MM:SS RESCH;APPLIC;TOPIC;MESS;DELAY;REPEAT

Ensure that this syntax is followed exactly, with spaces and semi-colons in the correct positions.

Where:

DD/MM/YYYY HH:MM:SS Is the time for the event to be scheduled. The time stamp must be in this form.

RESCH is the rescheduling factor. After the event has been executed, it will be rescheduled to re execute after this period.

APPLIC is the application to send the event to. If the application is followed by a (XXX) the Scheduler will send the instruction through the remote instruction system to the workstation identified by the XXX. In Windows For Workgroups the destination can be referred to by the computer name preceded by two back slashes.

TOPIC is the topic of the application. The topic can also be followed by a modifier. The modifier is the list identifier. The list identifier is a flag that identifies the item for the use of some other internal commands. Specifically the clearlist command

MESS is the command string that the application will use to perform its functions. There is no syntax for this part, it is the execution message sent to the APPLIC, the interpretation of this message is the responsibility of the receiving application.

DELAY is the delay to retry the event if the execution failed, in seconds. This is optional, but must be included if you wish to send a repeat parameter

REPEAT is how many times to repeat after a failure before giving up trying. If this is set to 0 then the event will be retried until the Scheduler is shut down. This is optional.

Examples

1) A straight command

12/01/1995 12:00:00 0;EXCEL;SYSTEM;[Run(Macro1.xlm!Macro1)];15;0

Will make EXCEL run the macro MACRO1 in the MACRO1.XLM spread sheet at midday on the 12th of January 1995. If it fails it will try again in 15 seconds.

2) A rerun command

12/01/1995 12:00:00 1h;EXCEL;SYSTEM;[Run(Macro1.xlm!Macro1)];15;0

Starting at midday on the 12th of January run every hour.

3) A run NOW command

00/00/1900 00:00:00 1h;EXCEL;SYSTEM;[Run(Macro1.xlm!Macro1)];15;0

Run NOW and every hour after.

4) A run at shut down command

99/99/9999 00:00:00 1h;EXCEL;SYSTEM;[Run(Macro1.xlm!Macro1)];15;0

Run as the scheduler is unloaded.

5) Other variations exist.

The starting time is set according to the time entered.

IE if the time is 00:30:00 1h;....

then the command is ryun every hour on the half hour.

Mix and match the commands to see what happens.

See also

Internal Commands


Scheduler Files

The scheduler uses:

SCHINIT.001

This contains all the scheduled events for the Scheduler to read in at startup, IE the events that are required to be there each day, and that the operator does not want to add every day.

RISEND.001

This is the remote instruction file, items written here are read into the Scheduler when it gets a READFILE instruction, the file is read in full then deleted.


Command line parameters

The scheduler makes use of the command line parameters. It identifies the network drive that is shared and the workstation. IE If workstation one shared drive G: then the command line for the scheduler would read WBSCHED G001.

NOTE: The workstation Id must be three characters long.

See also

Scheduler Files


Read File

Forces the scheduler to read in its own remote instruction file.

See also

Command Line Parameters

Internal Commands

ReadFile


Add an item

This brings up a dialog box and allows the operator to enter an event manually.

See also

DDE Commands For The Scheduler


Launch On Error

If this item is checked then the schedule will attempt to launch the application if there was an error with the DDE transmission that indicates that the application is not running. The limitation is in that the scheduler has no knowledge of the path to the application and thus can only launch the application if it on the path.

See also

Internal Commands

Launch


Pause Transmission

If checked this will cause the scheduler to pause the transmissions until it is unchecked. The transmissions will not be sent, rescheduled, deleted or any other action taken. Thus when the option in unchecked the scheduler will attempt to catch up by transmitting and rescheduling everything as soon as possible.

See also:

HaltTx


Halt Transmission

If checked the scheduler stops transmitting the events in its list but continues to action them, rescheduling, deleting etc.

This option can be controlled through the use of the internal commands.

See also

Internal Commands

HaltTx

Pause Transmissions


Clock

If checked the scheduler will display the time in the upper right corner.


Logon Details
Enter Logon details for SQL

Allows the entry of ODBC login details used in conjunction with the SQL internal command.


Help

Brings up this help screen.


About

Displays an information box containing information regarding the version number of the scheduler and the registration details of the system.


Internal Commands

There are a series on internal commands

ReadFile

Exit

Quit

Beep

Write

Play

Launch

HaltTx

ClearList

Copy File

Check File

Hide

SQL

ODBC

These commands can be sent to the scheduler at anytime, but must have the same syntax as any other DDE Command. They are case insensitive. The application name for these commands is INTERNAL.


HaltTx

The command HALTTX with message true, checks the HaltTx menu option.

If the message was False then it will uncheck the HaltTx menu option.

If it is neither then the HaltTx Menu option will be toggled.

See also

Internal Commands

HaltTx


SQL Command
SQL/ODBC

The command SQL while cause the scheduler to log on to an ODBC compliant database using the details entered into the Enter Logon Details For SQL menu item, and run the message. No database rows should be returned, only the number of rows affected

See also

Internal Commands


HideCmd
Hide Scheduler

The command HIDE with message true, will cause the scheduler to hide itself. If the message is anything other than True the scheduler will reappear as an icon.

See also

Internal Commands


ReadFile

Will cause the scheduler to read its remote instruction file.

See also

Internal Commands

Read File

Scheduler Files


ClearList

This will empty the scheduler's event list, based on the message. The command will clear all events that are flagged with the same list identifier as that sent. If the message part was ALL then the scheduler will clear it's entire list of events completely.

See Also

Internal Commands


Beep

This will cause the scheduler to beep.

See also

Internal Commands

Play


Play

This will cause the scheduler to play the WAV file listed in the Message.

See also

Internal Commands

Beep


Write

This will cause the scheduler to write out, once, the message in its own LastOut box.

See also

Internal Commands


Copy File

Syntax of the message is:

FileA,FileB

This will cause the schedule to copy FileA to FileB

See also

Internal Commands


Check File

Syntax of the message is:

FileName, TimeStamp, Notify Application, Notify Topic, Notify Message, Period

This will cause the schedule to check the time stamp on FileName if it is later than TimeStamp the scheduler will send of a DDE message to Notify Application, Notify Topic and reschedule the CheckFile command adjusting the time stamp to read the current file time stamp plus Period.

Eg

C:\WINBOX\TREND.CSV, 34090, EXCEL,SYSTEM,[RUN("FILEUPDATED")],1 will execute the FILEUPDATED macro in EXCEL when the date of C:\WINBOX\TREND.CSV is after 01/05/1993 00:00:00 and then will reschedule the command to read:

C:\WINBOX\TREND.CSV, 34091, EXCEL,SYSTEM,[RUN("FILEUPDATED")],1

See also

Internal Commands


Exit Or Quit

Causes the scheduler to stop, and exit

See also

Internal Commands


Launch

The command Launch with message true, checks the Launch On Error menu option.

If the message was False then it will uncheck the Launch On Error menu option.

If it is neither then the Launch On Error Menu option will be toggled.

See also

Internal Commands

Launch On Error